SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


CREATE PROCEDURE [dbo].[usp_GetTopFiveCorperateCompany]
AS 
    SELECT TOP ( 5 )
            JOL_Employer_Account,
            JOL_Employer_Name,
            JOL_Employer_Industry,
            JOL_Employer_Type,
			convert(varchar(10),JOL_Employer_VerifyTime,120)		-- doo 20110215  
    FROM    dbo.JOL_Employer
	where JOL_Employer_VerifyStatus = '已审核'	and					-- doo 20110215
			JOL_Employer_IsSchoolCorperate = 1
    ORDER BY JOL_Employer_VerifyTime DESC,JOL_Employer_AddTime DESC	-- doo 20110215
GO
